USE [genshi]
GO

/****** Object:  Trigger [dbo].[dele_down]    Script Date: 2022/5/3 20:28:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[dele_down] ON [dbo].[Assemble]
AFTER DELETE 
AS
Begin
	SET NOCOUNT ON;
	UPDATE Relics
	set equipped = null
	where exists(Select * from deleted where id = Flower or id = Feather or id = Sand or id = Cup or id = Head);
End
GO

ALTER TABLE [dbo].[Assemble] ENABLE TRIGGER [dele_down]
GO

